www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/fkm.cpp
// fkm.cpp : implementation file // #include "stdafx.h" #include "khmanager.h" #include "fkm.h" #include "ado.h" #include "khfk.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // fkm dialog fkm::fkm(CWnd* pParent /*=NULL*/) : CDialog(fkm::IDD, pParent) { //{{AFX_DATA_INIT(fkm) // NOTE: the ClassWizard will add member initialization here //}}AFX_DATA_INIT } void fkm::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(fkm) DDX_Control(pDX, IDC_LIST1, m_list); DDX_Control(pDX, IDC_COMBO1, m_com); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(fkm, CDialog) //{{AFX_MSG_MAP(fkm) ON_BN_CLICKED(IDC_BUTTON1, OnButton1) ON_BN_CLICKED(IDC_BUTTON2, OnButton2) ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // fkm message handlers BOOL fkm::OnInitDialog() { CDialog::OnInitDialog(); ado rst; rst.Open("select * from tb_Client_khmyd",adCmdText); int rstnum=rst.GetRecordCount(); int i; for(i=1;i<=rstnum;i++) { this->m_com.AddString(rst.GetFieldValue("khmyd_myd")); rst.Move(i); } rst.close(); m_list.ModifyStyle(0L,LVS_REPORT); // m_list.ModifyStyle(0L,LVS_SINGLESEL); m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS); m_list.ModifyStyle(0L,LVS_NOSORTHEADER); m_list.SetExtendedStyle(LVS_EX_GRIDLINES| LVS_EX_FULLROWSELECT| LVS_EX_HEADERDRAGDROP| LVS_EX_ONECLICKACTIVATE); m_list.InsertColumn(0,"意见反馈编号"); m_list.InsertColumn(1,"反馈标题"); m_list.InsertColumn(2,"客户名称"); m_list.InsertColumn(3,"反馈内容"); m_list.InsertColumn(4,"反馈日期"); m_list.InsertColumn(5,"受理人"); m_list.InsertColumn(5,"客户满意度"); m_list.InsertColumn(5,"备注信息"); m_list.SetColumnWidth(0,100); m_list.SetColumnWidth(1,100); m_list.SetColumnWidth(2,100); m_list.SetColumnWidth(3,100); m_list.SetColumnWidth(4,100); m_list.SetColumnWidth(5,100); m_list.SetColumnWidth(6,100); m_list.SetColumnWidth(7,100); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void fkm::OnButton1() { this->EndDialog(true); } void fkm::loadlist() { ado rst; rst.rstOpen("select * from tb_Client_khfk"); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("khfk_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("khfk_fkbt")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("khfk_khmc")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("khfk_fknr")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("khfk_fkrq")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("khfk_fkslr")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("khfk_khmyd")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("khfk_bz")); rst.Move(ii); } rst.close(); } void fkm::OnButton2() { this->m_list.DeleteAllItems(); CString com,sql; this->m_com.GetWindowText(com); if(com.IsEmpty()) {MessageBox("请选择","提示"); return;} sql.Format("select * from tb_Client_khfk where khfk_khmyd='%s'",com); ado rst; rst.Open(sql,adCmdText); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("khfk_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("khfk_fkbt")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("khfk_khmc")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("khfk_fknr")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("khfk_fkrq")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("khfk_fkslr")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("khfk_khmyd")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("khfk_bz")); rst.Move(ii); } rst.close(); } void fkm::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) { int i=m_list.GetHotItem(); if(i<0) {return;} KHFK fk; fk.edit1=this->m_list.GetItemText(i,0); fk.edit2=this->m_list.GetItemText(i,1); fk.edit5=this->m_list.GetItemText(i,2); fk.edit6=this->m_list.GetItemText(i,3); fk.edit7=this->m_list.GetItemText(i,4); fk.DoModal(); *pResult = 0; }